ArcFM Responder Mobile Developer Guide
Select(DataSession,String,IDbLoaderCriteria,String[]) Method






A database connection and transaction information
The database table to query
The columns requested
Create and populates a DataTable with the requested data. Creates and populates a DataTable with the requested data.
Syntax
'Declaration
 
Public Overloads Function Select( _
   ByVal session As DataSession, _
   ByVal tableName As System.String, _
   ByVal criteria As IDbLoaderCriteria, _
   ByVal columns() As System.String _
) As System.Data.DataTable
'Usage
 
Dim instance As DataLoader
Dim session As DataSession
Dim tableName As System.String
Dim criteria As IDbLoaderCriteria
Dim columns() As System.String
Dim value As System.Data.DataTable
 
value = instance.Select(session, tableName, criteria, columns)
public System.Data.DataTable Select( 
   DataSession session,
   System.string tableName,
   IDbLoaderCriteria criteria,
   System.string[] columns
)
public function Select( 
    session: DataSession;
    tableName: System.String;
    criteria: IDbLoaderCriteria;
    columns: System.Stringarray of
): System.Data.DataTable; 
public function Select( 
   session : DataSession,
   tableName : System.String,
   criteria : IDbLoaderCriteria,
   columns : System.String[]
) : System.Data.DataTable;
public: System.Data.DataTable* Select( 
   DataSession* session,
   System.string* tableName,
   IDbLoaderCriteria* criteria,
   System.string*[]* columns
) 
public:
System.Data.DataTable^ Select( 
   DataSession^ session,
   System.String^ tableName,
   IDbLoaderCriteria^ criteria,
   System.array<String^>^ columns
) 

Parameters

session
A database connection and transaction information
tableName
The database table to query
criteria
columns
The columns requested

Return Value

A DataTable that contains the resultset matching the given criteria
Remarks
You can think of this method returning a DataTable populated with data from the following query: "select (*|columns) from tableName where criteria"
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

DataLoader Class
DataLoader Members
Overload List

Send Feedback